DETALLEINGRESOHQ

"192.168.0.1:sipop"

DETALLEINGRESOHQ

Descriptions

DETALLE DE INGRESO DE BODEGA DE HERRAMIENTAS Y EQUIPO

Fields

Name	Domain	Data type
REGISTRO_INGRESO		CHAR (8)
ARTICULO		CHAR (8)
EXISTENCIA		FLOAT
CANTIDAD		FLOAT
PRECIOUNITARIO		FLOAT
DESCUENTO		FLOAT
OTROSCARGOS		FLOAT
COSTO_UNITARIO_IVA		FLOAT
COSTO_UNITARIO_SINIVA		FLOAT
TOTAL_AFECTA		FLOAT
TOTAL_EXCENTOS		FLOAT
ACTIVO	BOOLEAN	VARCHAR (5)

Triggers

Trigger	Type	Active	Position	Description
DETALLEINGRESOHQ_AI	After Insert		0
DETALLEINGRESOHQ_BI	Before Insert		0

Indices

Index	Fields	Active	Unique	Order
PK_DETALLEINGRESOHQ	REGISTRO_INGRESO, ARTICULO			Ascending

References

Table	Foreign Key	Fields	FK Fields	DEL Rule	UPD Rule
REGISTRODEINGRESO	INTEG_277	REGISTRO_INGRESO	ID_REGISTRO_INGRESO	RESTRICT	RESTRICT
INVENTARIO	INTEG_279	ARTICULO	ID_ARTICULO	RESTRICT	RESTRICT

Referenced

There are no tables referenced by table DETALLEINGRESOHQ

Definition


CREATE TABLE DETALLEINGRESOHQ (
    REGISTRO_INGRESO CHAR (8) CHARACTER SET NONE NOT NULL COLLATE NONE,
    ARTICULO CHAR (8) CHARACTER SET NONE NOT NULL COLLATE NONE,
    EXISTENCIA FLOAT NOT NULL,
    CANTIDAD FLOAT NOT NULL,
    PRECIOUNITARIO FLOAT NOT NULL,
    DESCUENTO FLOAT,
    OTROSCARGOS FLOAT,
    COSTO_UNITARIO_IVA FLOAT,
    COSTO_UNITARIO_SINIVA FLOAT,
    TOTAL_AFECTA FLOAT,
    TOTAL_EXCENTOS FLOAT,
    ACTIVO BOOLEAN);

ALTER TABLE DETALLEINGRESOHQ ADD CONSTRAINT PK_DETALLEINGRESOHQ PRIMARY KEY (REGISTRO_INGRESO, ARTICULO);
ALTER TABLE DETALLEINGRESOHQ ADD  FOREIGN KEY (REGISTRO_INGRESO) REFERENCES REGISTRODEINGRESO (ID_REGISTRO_INGRESO);
ALTER TABLE DETALLEINGRESOHQ ADD  FOREIGN KEY (ARTICULO) REFERENCES INVENTARIO (ID_ARTICULO);

This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m.